Variable Order
Variables must be defined above and to the left of their use. For example:
If df is defined in D3, F3/F5 (below/right) can use df, but D2 (above) or F2 (left) cannot (Figure 3-12).
Calculation Mode
Default auto-calculation refreshes formulas frequently—switch to Manual Calculation to avoid this.
Python Limitations
Max dataset size: 100MB.
No access to local devices/network resources.
Cannot mix with worksheet functions.
This chapter covers the basics of Excel’s built-in Python. Practice the examples to master its workflow1